Notes/Domino 6 and 7 Forum : RE: How to get 7 values out of more than 2'000'000 documents

Thanks a lot Andre for your helpful answer.

I will try your sugestions with a view sorted by user. This can be the trick.

I was also thinking about the putting the categories in the users document. The only thing is here that there is a log db for each year. So, if I want to know all the categories of a user I have to run over all dbs and there are 20 of them and all have more than 2'000'000 documents and this for several tousand users. Even if we have quite good hardware this could take for ever.
Well, here is also the question whether it needs to be for all years or just from now on. But this is not my decision due I am the programer.

I will try to explain the problem a little bit better.

In our web app the users can search for information. Each search is done with a specified categories specified by the user. So, some user's have 100 categories and others just two or three. The information the searched is charged and thus logged in this database which is FT indexed.
Now, there was the request of some users to see the charges of them online. They also would like to see the cost split by the categories, month and search type(there are four different information systems)

So I need to get all charge documents of a user grouped by category and then grouped by date and at the end also grouped by search type.

I will do some test now with your suggestions and see what is the fastest way. For sure any solution will need time to get the information.

It would be a nice feature to use some basic SQL statements on a view or documents in a database or collection, would not be?

Notes/Domino 6 and 7 Forum

Document Options

Search this forum

Forum views and search

Member Tools

RSS Feeds